USE [Exp]
GO
/****** Object:  Table [dbo].[Invoice_import]    Script Date: 12/01/2022 16:28:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_import](
	[Inv_importID] [bigint] IDENTITY(1,1) NOT NULL,
	[Inv_importDate] [datetime] NOT NULL,
	[Inv_importVNo] [varchar](16) NOT NULL,
	[SessionID] [smallint] NOT NULL,
	[Remarks] [varchar](150) NULL,
	[ReadOnly] [bit] NOT NULL CONSTRAINT [DF_Invoice_import_ReadOnly]  DEFAULT ((0)),
	[LoginID] [int] NOT NULL,
	[HostName] [varchar](50) NULL CONSTRAINT [DF_Invoice_import_HostName]  DEFAULT ('hostname()'),
	[EntryDateTime] [datetime] NULL CONSTRAINT [DF_Invoice_import_EntryDateTime]  DEFAULT (getdate()),
	[ModifyID] [int] NULL,
	[ModifyHostName] [varchar](50) NULL CONSTRAINT [DF_Invoice_import_ModifyHostName]  DEFAULT ('hostname()'),
	[ModifyDateTime] [datetime] NULL CONSTRAINT [DF_Invoice_import_ModifyDateTime]  DEFAULT (getdate()),
	[BLDate] [datetime] NULL,
	[ReturnDate] [datetime] NULL,
	[importDate] [varchar](100) NULL,
	[ExporterID] [int] NULL,
	[SupplierID] [int] NULL,
	[ConsigneeID] [int] NULL,
	[SubPartyID] [smallint] NULL,
	[AgentID] [int] NULL,
	[importID] [int] NULL,
	[TransporterID] [int] NULL,
	[ShipID] [smallint] NULL,
	[ShipLineID] [smallint] NULL,
	[ContainerTypeID] [smallint] NULL,
	[StatusID] [smallint] NULL,
	[GD] [varchar](250) NULL,
	[BLNo] [varchar](50) NULL,
	[VoyNo] [varchar](50) NULL,
	[Currency] [varchar](50) NOT NULL,
	[importRef] [varchar](100) NULL,
	[EFormNo] [varchar](200) NULL,
	[ContainerNo] [varchar](200) NULL,
	[NoOfContainers] [decimal](11, 0) NOT NULL CONSTRAINT [DF_Invoice_import_NoOfContainers]  DEFAULT ((0)),
	[SumQTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumPkg]  DEFAULT ((0)),
	[SumNetWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumNetWT]  DEFAULT ((0)),
	[SumGrossWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumGrossWT]  DEFAULT ((0)),
	[SumGWTotal] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumGWTotal]  DEFAULT ((0)),
	[SumNetTotal] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumQty]  DEFAULT ((0)),
	[SumAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumAmount]  DEFAULT ((0)),
	[NetInvoice] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_NetInvoice]  DEFAULT ((0)),
	[SumRemit] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumRemit]  DEFAULT ((0)),
	[SumFBC] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumFBC]  DEFAULT ((0)),
	[SumRemitNet] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumRemitNet]  DEFAULT ((0)),
	[SumFAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumFAmount]  DEFAULT ((0)),
	[SumGD] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_import_SumGD]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_import] PRIMARY KEY CLUSTERED 
(
	[Inv_importID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_importEForm]    Script Date: 12/01/2022 16:28:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_importEForm](
	[inv_importEFormID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_importID] [bigint] NOT NULL,
	[EFormID] [bigint] NULL,
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_importEForm_Type]  DEFAULT ((0)),
	[GDNo] [varchar](50) NULL,
	[GDDate] [datetime] NULL,
	[GDAmount] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importEForm_GDAmount]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_importEForm] PRIMARY KEY CLUSTERED 
(
	[inv_importEFormID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_importItem]    Script Date: 12/01/2022 16:28:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_importItem](
	[inv_importItemID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_importID] [bigint] NOT NULL,
	[StationID] [smallint] NULL,
	[ItemID] [smallint] NULL,
	[VarietyID] [smallint] NULL,
	[LQTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importItem_LQTY]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_importItem_Type]  DEFAULT ((0)),
	[ContainerNo] [varchar](20) NULL,
 CONSTRAINT [PK_Invoice_importItem] PRIMARY KEY CLUSTERED 
(
	[inv_importItemID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_importPacking]    Script Date: 12/01/2022 16:28:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_importPacking](
	[inv_importPackID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_importID] [bigint] NOT NULL,
	[ShipMarkID] [smallint] NULL,
	[PackageID] [smallint] NULL,
	[ItemID] [smallint] NULL,
	[QTY] [numeric](15, 0) NOT NULL CONSTRAINT [DF_Invoice_importPacking_QTY]  DEFAULT ((0)),
	[NetWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importPacking_NetWT]  DEFAULT ((0)),
	[GrossWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importPacking_GrossWT]  DEFAULT ((0)),
	[GWTotal] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importPacking_GWTotal]  DEFAULT ((0)),
	[NetTotal] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importPacking_NetTotal]  DEFAULT ((0)),
	[Rate] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importPacking_Rate]  DEFAULT ((0)),
	[Amount] [numeric](15, 4) NOT NULL,
	[Type] [tinyint] NOT NULL,
	[ItemRemarks] [varchar](30) NULL,
	[RateRemarks] [varchar](30) NULL,
	[RateType] [varchar](30) NULL,
	[PRemarks] [varchar](50) NULL,
	[PAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importPacking_PAmount]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_importPacking] PRIMARY KEY CLUSTERED 
(
	[inv_importPackID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_importRemit]    Script Date: 12/01/2022 16:28:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_importRemit](
	[inv_importRemitID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_importID] [bigint] NOT NULL,
	[importID] [int] NULL,
	[Remit] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importRemit_Remit]  DEFAULT ((0)),
	[FBC] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importRemit_FBC]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_importRemit_Type]  DEFAULT ((0)),
	[importDate] [datetime] NOT NULL,
	[EPRC] [varchar](100) NULL,
	[RemitNet] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_importRemit_RemitNet]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_importRemit] PRIMARY KEY CLUSTERED 
(
	[inv_importRemitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF